﻿/* -------------------HIEP--------------------- */
USE QUANLYGIAODUC
GO

ALTER TABLE dbo.SINHVIEN ADD
	GIOITINH int,
	NOISINH           nvarchar (50)
GO


USE QUANLYGIAODUC
GO
-- DROP PROCEDURE dbo.SINHVIEN_add
CREATE PROCEDURE dbo.SINHVIEN_add
@maSinhVien int,
@maKhoa int,
@maKhoaHoc int,
@hoTen nvarchar (20),
@gioiTinh int,
@ngaySinh datetime,
@noiSinh nvarchar (50),
@diaChi nvarchar (50),
@email nvarchar (20),
@soDienThoai nvarchar (20),
@matKhau nvarchar (20),
@tenDangNhap varchar (80)
AS
begin
	insert into SINHVIEN (MASINHVIEN, MAKHOA, MAKHOAHOC,HOTEN, GIOITINH, NGAYSINH, NOISINH, DIACHI, EMAIL, SODIENTHOAI, VIPHAMKILUAT, DANGKIKHOALUAN, MATKHAU, TENDANGNHAP)
	values (@maSinhVien, @maKhoa, @maKhoaHoc, @hoTen, @gioiTinh, @ngaySinh, @noiSinh, @diaChi, @email, @soDienThoai, '', '', @matKhau, @tenDangNhap)
end
RETURN
GO
